package cn.itcase.jdbc.example;

import java.sql.*;

public class Example01 {
    public static void main(String[] args) throws SQLException{
        Statement stmt=null;
        ResultSet rs=null;
        Connection conn=null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            String url="jdbc:mysql://localhost:3306/jdbc?serverTimezone=GMT%2B8";
            String username="root";
            String password="zky83826";
            conn= DriverManager.getConnection(url,username,password);
            stmt=conn.createStatement();
            String sql="select * from users";
            rs= stmt.executeQuery(sql);
            System.out.println("id|name|password|birthday");
            while(rs.next()){
                int id=rs.getInt("id");
                String name=rs.getString("name");
                String psw=rs.getString("password");
                Date birthday=rs.getDate("birthday");
                System.out.println(id+"|"+name+"|"+psw+"|"+birthday);
            }

        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }finally {
            if(rs!=null){
                try{
                    rs.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
                rs=null;
            }
            if(stmt!=null){
                try {
                    stmt.close();
                }catch (SQLException e){
                    e.printStackTrace();
                }
                stmt=null;
            }
            if(conn!=null){
                try{
                    conn.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
                conn=null;
            }
        }
    }
}
